Breaking Microsoft Excel DDE Links

Modified on 2012/03/12 14:34 by Nate Ostrye (CTS) — Categorized as: Uncategorized

Excel will allow a user to manually edit excel links. This provides the opportunity for end user error in the form of a typo as Excel DDE links are case sensitive. If a typo occurs the user will have no choice but to remove the broken link and create it correctly from scratch. This is a limitation in Excel.

An example would be if the month is changed using lower case charactors. Excel won't allow the correction of the formula and the formula will never again work.

In Excel 2010 go to the Data tab and click Edit Links.

A dialog will be displayed.

Find the broken link and click "Break Link" and close the dialog.

Use T4 to generage the correct link so that there is no chance of a typo.

Image